<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN">
<html>
<head>
<title>public</title>
    <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
    <meta name="generator" content="Doc-O-Matic" />
    <meta http-equiv="Content-Style-Type" content="text/css" />
    <link rel="STYLESHEET" href="default.css" type="text/css" />

<script type="text/javascript" src="scripts.js"></script>
</head>
<body class="Element700" onload="onBodyLoadEx('frames.html', 'topic', '!!MEMBERVISIBLITY_public_TLzTable.html');" onmousedown="onBodyMouseDown();">

<!-- Begin Popups -->

<!-- End Popups -->

<!-- Begin Page Header -->
<div class="Element710" id="areafixed">
<div class="Element94">
<em>You are here:</em> Symbol Reference &gt; <a href="!!CLASSES.html" target="topic">Classes</a> &gt; <a href="TLzTable.html" target="topic">TLzTable Class</a> &gt; <a href="!!MEMBERVISIBLITY_public_TLzTable.html" target="topic">public</a></div>
<div class="Element92">
<table width="100%" cellspacing="0" cellpadding="0">
<tr><td width="50%">
<div class="Element2">
<a href="contents.html" target="tocidx"><img src="btn_globals_contents_midblue.gif" border="0" alt="Contents" title="Contents" onmouseover="switchImage(this, 'btn_globals_contents_midblue_hover.gif');" onmouseout="switchImage(this, 'btn_globals_contents_midblue.gif');"></a><a href="idx.html" target="tocidx"><img src="btn_globals_index_midblue.gif" border="0" alt="Index" title="Index" onmouseover="switchImage(this, 'btn_globals_index_midblue_hover.gif');" onmouseout="switchImage(this, 'btn_globals_index_midblue.gif');"></a><a href="index.html" target="topic"><img src="btn_globals_home_midblue.gif" border="0" alt="Home" title="Home" onmouseover="switchImage(this, 'btn_globals_home_midblue_hover.gif');" onmouseout="switchImage(this, 'btn_globals_home_midblue.gif');"></a></div>
</td><td width="50%">
<div class="Element90">
<a href="TLzTable.html" target="topic"><img src="btn_prev_midblue.gif" border="0" alt="Previous" title="Previous" onmouseover="switchImage(this, 'btn_prev_midblue_hover.gif');" onmouseout="switchImage(this, 'btn_prev_midblue.gif');"></a><a href="TLzTable.html" target="topic"><img src="btn_up_midblue.gif" border="0" alt="Up" title="Up" onmouseover="switchImage(this, 'btn_up_midblue_hover.gif');" onmouseout="switchImage(this, 'btn_up_midblue.gif');"></a><a href="TLzTable_containfreetable.html" target="topic"><img src="btn_next_midblue.gif" border="0" alt="Next" title="Next" onmouseover="switchImage(this, 'btn_next_midblue_hover.gif');" onmouseout="switchImage(this, 'btn_next_midblue.gif');"></a></div>
</td></tr></table><div class="Element5">
public</div>
</div>
</div>

<!-- End Page Header -->

<!-- Begin Client Area -->
<div class="Element720" id="areascroll">
<div class="Element721">

<!-- Begin Page Content -->
<div class="Element58">
<a name="Summary"></a><div class="Element11">
<div class="Element10">
<p class="Element10">
The public members of the TLzTable class are listed here.</p></div>
</div>
<a name="Fields"></a><div class="Section1000030">
Fields</div>
<div class="Element10030">
<div class="Section30">
<div class="Element212">
<div class="TableDiv">
<table cellspacing="0" class="Table0">
<tr>
<td class="Element200" valign="top" width="35%">
<div class="Element201">
Field&nbsp;</div></td><td class="Element204" valign="top" width="65%">
<div class="Element205">
Description&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<img src="indicator_public.png" border="0" alt="" title=""> <a href="TLzTable_containfreetable.html" target="topic">containfreetable</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
 <br>Points to CONTAINSTABLE of Mssql.&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<img src="indicator_public.png" border="0" alt="" title=""> <a href="TLzTable_dctr.html" target="topic">dctr</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
 <br>Data change table reference clause of DB2.&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<img src="indicator_public.png" border="0" alt="" title=""> <a href="TLzTable_DmlStmt.html" target="topic">DmlStmt</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
 <br>If data source is data change table clause of DB2, the DmlStmt is insert/delete/update statement.&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<img src="indicator_public.png" border="0" alt="" title=""> <a href="TLzTable_FlashbackClause.html" target="topic">FlashbackClause</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
 <br>Flashback clause for table in Oracle.&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<img src="indicator_public.png" border="0" alt="" title=""> <a href="TLzTable_isfunction.html" target="topic">isfunction</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
 <br>This data source is derived from a function.&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<img src="indicator_public.png" border="0" alt="" title=""> <a href="TLzTable_IsTable.html" target="topic">IsTable</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
 <br>Data source is a table source like this:<br>table ( subquery )<br>or<br>table ( expression )&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<img src="indicator_public.png" border="0" alt="" title=""> <a href="TLzTable_mshintlist.html" target="topic">mshintlist</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
 <br>Points to table hints of mssql.&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<img src="indicator_public.png" border="0" alt="" title=""> <a href="TLzTable_OnlyOuterToken.html" target="topic">OnlyOuterToken</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
 <br>Only keyword in syntax like this in DB2.<br><br>Only ( qualified name )&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<img src="indicator_public.png" border="0" alt="" title=""> <a href="TLzTable_openrowset.html" target="topic">openrowset</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
 <br>Data source is open row set of ms sql server.&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<img src="indicator_public.png" border="0" alt="" title=""> <a href="TLzTable_openxml.html" target="topic">openxml</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
Data source is open xml of ms sql server.&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<img src="indicator_public.png" border="0" alt="" title=""> <a href="TLzTable_pivottable.html" target="topic">pivottable</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
 <br>Data source is pivot and unpivot clause of ms sql server.&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<img src="indicator_public.png" border="0" alt="" title=""> <a href="TLzTable_PxGranule.html" target="topic">PxGranule</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
 <br>Px Granule Clause of data source in Oracle.&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<img src="indicator_public.png" border="0" alt="" title=""> <a href="TLzTable_SubQuery.html" target="topic">SubQuery</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
<a href="TLzTable_TableType.html" target="topic">TableType</a> is lttSubquery, this property points to an select statement which type is <a href="TSelectSqlStatement.html" target="topic">TSelectSqlStatement</a>.&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<img src="indicator_public.png" border="0" alt="" title=""> <a href="TLzTable_TableAttr.html" target="topic">TableAttr</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
 <br><a href="TLzTable_TableType.html" target="topic">TableType</a> is lttAttr, this property points to a qualified name which type is <a href="TLz_Attr.html" target="topic">TLz_Attr</a>.&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<img src="indicator_public.png" border="0" alt="" title=""> <a href="TLzTable_TableExpr.html" target="topic">TableExpr</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
<a href="TLzTable_TableType.html" target="topic">TableType</a> is lttExpr, this property points to an expression which type is <a href="TLzCustomExpression.html" target="topic">TLzCustomExpression</a>.&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<img src="indicator_public.png" border="0" alt="" title=""> <a href="TLzTable_TableSample.html" target="topic">TableSample</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
 <br>Table sample clause.&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<img src="indicator_public.png" border="0" alt="" title=""> <a href="TLzTable_TableType.html" target="topic">TableType</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
 <br>Type of this data source.&nbsp;</div></td></tr></table></div></div>
</div>
</div>
<a name="Properties"></a><div class="Section1000030">
Properties</div>
<div class="Element10030">
<div class="Section30">
<div class="Element212">
<div class="TableDiv">
<table cellspacing="0" class="Table0">
<tr>
<td class="Element200" valign="top" width="35%">
<div class="Element201">
Property&nbsp;</div></td><td class="Element204" valign="top" width="65%">
<div class="Element205">
Description&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<img src="indicator_public.png" border="0" alt="" title=""> <a href="TLzTable_DbLink.html" target="topic">DbLink</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
 <br>Database link of this table.&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<img src="indicator_public.png" border="0" alt="" title=""> <a href="TLzTable_DisplayName.html" target="topic">DisplayName</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
Table alias if any, or table name if table alias doesn't exits.&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<img src="indicator_public.png" border="0" alt="" title=""> <a href="TLzTable_Fields.html" target="topic">Fields</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
 <br>If table in create table statement, then Fields contain columns information in create table statement.&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<img src="indicator_public.png" border="0" alt="" title=""> <a href="TLzTable_IsHasAs.html" target="topic">IsHasAs</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
 <br>Is as keyword in table alias.&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<img src="indicator_public.png" border="0" alt="" title=""> <a href="TLzTable_IsPhysicalTable.html" target="topic">IsPhysicalTable</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
 <br>Check is this table a derived table of physical table.&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<img src="indicator_public.png" border="0" alt="" title=""> <a href="TLzTable_TableAlias.html" target="topic">TableAlias</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
 <br>Table alias in string. Doesn't contain as keyword.&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<img src="indicator_public.png" border="0" alt="" title=""> <a href="TLzTable_TableDesc.html" target="topic">TableDesc</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
 <br>Full table name includes table alias. Same as AsText property.&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<img src="indicator_public.png" border="0" alt="" title=""> <a href="TLzTable_TableFullname.html" target="topic">TableFullname</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
 <br>Full table name which includes table prefix(usually, it's server.database.schema).&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<img src="indicator_public.png" border="0" alt="" title=""> <a href="TLzTable_TableName.html" target="topic">TableName</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
 <br>Only table name, no table prefix, no table alias.&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<img src="indicator_public.png" border="0" alt="" title=""> <a href="TLzTable_TableOptions.html" target="topic">TableOptions</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
 <br>MySQL table options.&nbsp;</div></td></tr><tr>
<td class="Element202" valign="top" width="35%">
<div class="Element203">
<img src="indicator_public.png" border="0" alt="" title=""> <a href="TLzTable_TablePrefix.html" target="topic">TablePrefix</a>&nbsp;</div></td><td class="Element206" valign="top" width="65%">
<div class="Element207">
 <br>Prefix of table, usually, it's server.database.schema&nbsp;</div></td></tr></table></div></div>
</div>
</div>
</div>
<!-- End Page Content -->

<!-- Begin Page Footer -->
<div class="Element93">
<table width="100%" cellspacing="0" cellpadding="0">
<tr><td width="100%">
<div class="Element3">
Gudu software http://www.sqlparser.com</div>
</td></tr><tr><td width="100%">
<div class="Element97">
Send <a href="#" onclick="sendFeedback('info@sqlparser.com', 'Documentation Feedback', 'Project: General SQL Parser Help file%0ATopic ID: !!MEMBERVISIBLITY_public_TLzTable%0ATitle: public');">comments</a> about this topic.</div>
</td></tr></table></div>

<!-- End Page Footer -->
</div>
</div>

<!-- End Client Area -->
</body></html>